create external table jms_dm.dm_cusc_tyd_taking_customer_summary_dt
(
    proxy_area_code   string comment '代理区code',
    proxy_area_name   string comment '代理区名称',
    pick_network_code string comment '取件网点code',
    pick_network_name string comment '取件网点名称',
    customer_code     string comment '客户编号code',
    customer_name     string comment '客户编号名称',
    order_source_code string comment '订单来源code',
    order_source_name string comment '订单来源名称',
    order_total       int comment '订单票数',
    taking_num        int comment '已揽收票数	',
    date_time         string comment '日期'
) COMMENT '兔优达揽收-汇总'
    PARTITIONED BY ( dt STRING COMMENT '订单录入时间')
    STORED AS PARQUET
    LOCATION '/dw/hive/jms_dm.db/external/dm_cusc_tyd_taking_customer_summary_dt'
;
